<?xml version='1.0' encoding='ISO-8859-1' standalone='yes'?>
<!DOCTYPE html PUBLIC '-//W3C//DTD XHTML 1.1 plus MathML 2.0 plus SVG 1.1//EN' 'http://www.w3.org/2002/04/xhtml-math-svg/xhtml-math-svg.dtd'>
<html xmlns='http://www.w3.org/1999/xhtml' >
<head>
<title>Database documentation</title>
<meta http-equiv="Content-Type" content="text/html; charset=UTF8"/>
<style type='text/css'>
	 #dbs {font-family:Tahoma,Dialog,Sans-Serif;font-size:11px;background:#fff;width:80%;border-collapse:collapse;text-align:left;margin:20px;}
	 #dbs thead{background:#ddd;}
	 #dbs th{font-size:12px;font-weight:bold;color:#336;border-bottom:2px solid #336;padding:7px 8px;}
	 #dbs td{border-bottom:1px solid #ccc;color:#336;padding:3px 8px;white-space: pre;}
	 td.subpart{font-weight:bold;background:#ddd}
	 td.name{background:#f2f2f2}
	 #dbs tbody tr:hover td{color:#000;background:#fffcea;}
</style>
</head>

<body>
<svg xmlns='http://www.w3.org/2000/svg' xmlns:xlink='http://www.w3.org/1999/xlink'   width='812' height='750' viewbox='0 0 812 750' >
<style type='text/css'>
  text                { text-rendering: optimizeLegibility; fill:#000000; font-family: Candara, Dialog, Arial; font-size:12px; }
  text.fk             { fill:#6e1850; }
  text.pk             { fill:#0c31a1; }
  text.colType        { fill:#a9bdc6; }
  text.tableTitle     { fill:#0f0f0f; font-weight:bold; }
  path                { stroke:#4d423e; stroke-width:1.5; fill:none; }
  rect.grp            { opacity:0.5; stroke:#c2ab83; stroke-width:1; }
  rect.table          { fill:#ffffff; stroke:#495272; stroke-width:0.5; filter:url(#shadow); }
  line.table          { stroke:#495272; stroke-width:0.5; }
  rect.callout        { fill:url(#calloutGradient); stroke:#aea913; stroke-width:0.5; }
  path.callout        { fill:#f4f1a4; stroke:#aea913; stroke-width:0.5; }
</style>
<defs>
  <pattern id='layoutGradient' patternUnits='userSpaceOnUse' x='0' y='0' width='10' height='10' viewBox='0 0 10 10'>
    <rect x='0' y='0' width='10' height='10' style='fill:#f9f8f2;' />
    <line x1='5' y1='10' x2='5' y2='0' style='stroke:#949494;stroke-width:0.5;stroke-dasharray:1,9;'  />
  </pattern>
  <radialGradient id='layoutGradientOld' cx='20%' cy='20%' r='25%' fx='10%' fy='0%'>
	   <stop offset='0%' stop-color='#ffffff' />
    <stop offset='100%' stop-color='#efefef' />
  </radialGradient>
  <linearGradient id='tableHeaderGradient' x1='0%' y1='0%' x2='0%' y2='100%' >
          <stop offset='0%' stop-color='#eff7fc' stop-opacity='1'/> 
          <stop offset='50%' stop-color='#d9e5f6' stop-opacity='1'/> 
          <stop offset='51%' stop-color='#bdd4f1' stop-opacity='1'/> 
          <stop offset='100%' stop-color='#d6e2f9' stop-opacity='1' /> 
   </linearGradient>
  <radialGradient id='calloutGradient' cx='20%' cy='20%' r='100%' fx='10%' fy='10%'>
	   <stop offset='0%' stop-color='#ffffff' />
    <stop offset='100%' stop-color='#f4f1a4' />
  </radialGradient>
  <filter id='shadow' width='150%' height='150%'> 
    <feGaussianBlur in='SourceAlpha' stdDeviation='3' result='image1' /> 
    <feOffset in='image1' result='image2' dx='2' dy='2' />
    <feComposite in='SourceGraphic' in2='image2' operator='over' /> 
  </filter>
  <filter id='emboss'> 
    <feGaussianBlur in='SourceAlpha' stdDeviation='2' result='blur'/> 
    <feSpecularLighting in='blur' surfaceScale='-3' style='lighting-color:white' 
      specularConstant='1' specularExponent='16' result='spec' kernelUnitLength='1' >
      <feDistantLight azimuth='45' elevation='45' />
    </feSpecularLighting> 
    <feComposite in='spec' in2='SourceGraphic' operator='in' result='specOut'/> 
    <feComposite in='SourceGraphic' in2='specOut' operator='arithmetic' k1='0' k2='1' k3='1' k4='0' result='litPaint'/>  
  </filter>
  <filter id='embossAndShadow' filterUnits='userSpaceOnUse' x='0' y='0' width='400' height='120'> 
     <feGaussianBlur in='SourceAlpha' stdDeviation='4' result='blur'/> 
     <feOffset in='blur' dx='4' dy='4' result='offsetBlur'/> 
     <feSpecularLighting in='blur' surfaceScale='5' specularConstant='.75' specularExponent='20' lighting-color='#bbbbbb' result='specOut'>
        <fePointLight x='-5000' y='-10000' z='20000'/>  
     </feSpecularLighting> 
     <feComposite in='specOut' in2='SourceAlpha' operator='in' result='specOut'/> 
     <feComposite in='SourceGraphic' in2='specOut' operator='arithmetic' k1='0' k2='1' k3='1' k4='0' result='litPaint'/>  
     <feMerge> 
         <feMergeNode in='offsetBlur'/> 
         <feMergeNode in='litPaint'/> 
     </feMerge> 
  </filter> 
  <radialGradient id='legendGradient' fx='5%' fy='5%' r='75%' spreadMethod='pad'>
          <stop offset='0%' stop-color='#6985ff' stop-opacity='1'/> 
          <stop offset='100%' stop-color='#1e2a5f' stop-opacity='1' /> 
   </radialGradient>
  <pattern id='hintPointerSV' patternUnits='userSpaceOnUse' x='0' y='0' width='14' height='14' viewBox='0 0 14 14' >
      <path d='M 0,0 Q 7,7,0,13 Q 13,7,13,0' class='callout' />
  </pattern>
  <pattern id='hintPointerSE' patternUnits='userSpaceOnUse' x='0' y='0' width='14' height='14' viewBox='0 0 14 14' >
      <path d='M 0,0 Q 3,7,13,13 Q 7,7,13,0' class='callout' />
  </pattern>
  <pattern id='hintPointerNV' patternUnits='userSpaceOnUse' x='0' y='0' width='14' height='14' viewBox='0 0 14 14' >
      <path d='M 0,13 Q 7,7,0,0 Q 13,7,13,13' class='callout' />
  </pattern>
  <pattern id='hintPointerNE' patternUnits='userSpaceOnUse' x='0' y='0' width='14' height='14' viewBox='0 0 14 14' >
      <path d='M 0,13 Q 3,7,13,0 Q 7,7,13,13' class='callout' />
  </pattern>
  <symbol id='pk' overflow='visible' >
    <g transform='scale(0.85)'>
     <path style='fill:#e9ad16;stroke:#9c4f15;stroke-width:0.7;stroke-linecap:round;stroke-linejoin:round;filter:url(#emboss);'
        d='M 9.3678877,3.5695485 C 9.1030218,3.2729386 9.0796382,2.7628519 9.3396185,2.4517097 9.5449651,2.1956495 9.9040386,2.0980533 10.199638,2.2169415 10.533525,2.3415459 10.775153,2.706942 10.750675,3.0842709 10.737029,3.3980003 10.541153,3.699122 10.258248,3.8066067 9.966649,3.9250429 9.6169668,3.8418805 9.4008073,3.6062324 9.3894892,3.5943518 9.3785264,3.582104 9.3678886,3.5695487 z M 11.226617,6.9916004 C 11.888137,6.3548946 12.293488,5.4172188 12.311087,4.442353 12.378144,2.7379364 11.248678,1.0541269 9.7322318,0.44767357 8.3887112,-0.1280313 6.7865012,0.26822889 5.8918395,1.4007929 5.080823,2.3839145 4.9336815,3.8452096 5.3635544,5.101615 L 4.3670905,5.315913 C 4.0664984,5.3682645 4.0967703,5.6316724 4.2574957,5.8208829 L 4.9124,6.5655244 4.1543436,7.2512357 3.2136002,7.2163506 3.1674775,8.5586827 2.0406832,8.5086512 1.5965306,8.9299953 1.5471661,10.179833 0.75616674,10.195223 0.2112857,10.758575 0.15354288,11.735988 0.07199052,12.765553 c 0.36440953,0.238225 0.79006967,0.195492 1.44938278,-0.02675 L 6.3033562,8.1282037 6.8217102,8.6765688 C 6.9985465,8.8799427 7.3003699,8.7497574 7.358381,8.5016252 L 7.4938877,7.5084164 c 0.8537488,0.3985387 1.8303125,0.4711541 2.6851793,0.1427713 0.393927,-0.1407258 0.746858,-0.3701772 1.04755,-0.6595873 z'/>
     <path d='M 6.8014948,6.3102123 0.15369063,13.024481 0.21560535,12.141962 6.0062342,6.2683782 z'
        style='fill:#ffe5a5;fill-opacity:1;stroke:#854e31;stroke-width:0.09912433;stroke-linecap:round;stroke-linejoin:round;stroke-miterlimit:4;stroke-opacity:1;stroke-dasharray:none;stroke-dashoffset:3.00300009'/>
    </g>
  </symbol>
  <symbol id='unq' overflow='visible' >
    <g transform='scale(0.85)'>
      <rect style='fill:#e07554;stroke:#7e4d31;stroke-width:0.71934468;stroke-linecap:round;stroke-linejoin:round;'
         width='2.29' height='8.43' x='7.48' y='-0.76' ry='1.14' transform='matrix(0.701,0.713,-0.727,0.685,0,0)' />
      <path style='fill:#ffffe2;stroke:#313131;stroke-width:0.8;stroke-linecap:round;stroke-linejoin:round;stroke-miterlimit:4;'
         d='m 26.04,8.64 a 4.13,4.13 0 1 1 -8.26,0 4.13,4.13 0 1 1 8.26,0 z'
         transform='matrix(1.025,0,0,0.987,-14.690,-3.862)' />
      <text x='5.2' y='6.6' style='font-size:8px;fill:#7c0909;'>1</text>
    </g>
  </symbol>
  <symbol id='idx' overflow='visible' >
    <g transform='scale(0.85)'>
      <rect style='fill:#e07554;stroke:#7e4d31;stroke-width:0.71934468;stroke-linecap:round;stroke-linejoin:round;'
         width='2.29' height='8.43' x='7.48' y='-0.76' ry='1.14' transform='matrix(0.701,0.713,-0.727,0.685,0,0)' />
      <path style='fill:#ffffe2;stroke:#313131;stroke-width:0.8;stroke-linecap:round;stroke-linejoin:round;stroke-miterlimit:4;'
         d='m 26.04,8.64 a 4.13,4.13 0 1 1 -8.26,0 4.13,4.13 0 1 1 8.26,0 z'
         transform='matrix(1.025,0,0,0.987,-14.690,-3.862)' />
    </g>
  </symbol>
  <symbol id='fk' overflow='visible' >
    <path style='fill:#946d00;stroke:#5c2352;stroke-width:0.46;stroke-linecap:butt;stroke-linejoin:round;stroke-miterlimit:4;'
    d='M 12.48,0.33 7.07,0.89 9.067,2.974 0.329,11.731 1.073,12.597 9.811,3.841 11.77,5.78 z' />
  </symbol>
  <symbol id='ref' overflow='visible' >
  <path style='fill:#1877c8;stroke:#29365f;stroke-width:0.4;stroke-linecap:butt;stroke-linejoin:round;stroke-miterlimit:4;'
          d='M 0.10,12.70 5.31,12.15 3.40,10.06 11.82,1.32 11.11,0.45 2.68,9.19 0.80,7.24 z'/>
  </symbol>
  <marker id='arrow' viewBox='0 0 7 7' refX='0' refY='3' markerUnits='strokeWidth' markerWidth='7' markerHeight='7' orient='auto'>
    <path d='M 0,0 L 7, 3 L 0,7 z' style='fill:#776c57; stroke-width:0px;' />
  </marker>
  <marker id='foot' viewBox='0 0 7 7' refX='7' refY='3' markerUnits='strokeWidth' markerWidth='7' markerHeight='7' orient='auto'>
    <path d='M 0,3 L 14, 3 z' style='stroke:#776c57;' />
  </marker>
</defs>

<!-- ============= Desktop ============= -->
<rect x='1' y='1' width='810' height='748' rx='7' ry='7' style='fill:url(#layoutGradient); stroke:#104576; stroke-width:0.5;' />

<!-- ============= Legend ============= -->
<g transform='translate(10,10)'>
  <rect x='10' y='10' width='300' height='100' rx='6' ry='6' style='fill:url(#legendGradient);filter:url(#embossAndShadow);'/> 
  <text x='25' y='30' style='fill:white'>'Lelic' Database Schema</text> 
  <text x='25' y='44' style='fill:white'>'Lelic' Layout</text> 
  <a xlink:href='http://www.dbschema.com' title='Visit http://www.dbschema.com'> 
    <text x='25' y='58' style='fill:white'>Generated using DbSchema</text> 
  </a>

  <text x='25' y='80' style='fill:white'>Move the mouse over columns and symbols</text> 
  <a xlink:href='http://www.dbschema.com' title='Primary Key Icon'><use id='pk' x='240' y='72' xlink:href='#pk'/></a>  <a xlink:href='http://www.dbschema.com' title='Index Icon'><use id='idx' x='254' y='72' xlink:href='#idx'/></a>  <a xlink:href='http://www.dbschema.com' title='Foreign Key Icon'><use id='fk' x='268' y='72' xlink:href='#fk'/></a>  <text x='25' y='94' style='fill:white'>to read the tool-tip comments.</text> 
</g>

<g transform='translate(0,120)'>
<path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'    title='fk_mod_file_arquivo_autor mod_file_arquivo_autor to mod_file_autor ( id_autor -> id )' d='M 532 56 L 588,56'  />

<text x='541' y='52' transform='rotate(0 541,52)' title='fk_mod_file_arquivo_autor mod_file_arquivo_autor to mod_file_autor ( id_autor -> id )'>id_autor</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'    title='fk_mod_file_arquivo_autor_0 mod_file_arquivo_autor to mod_file_arquivo ( id_arquivo -> id )' d='M 378 84 L 329,84 Q 322,84 322,91 L 322,140'  />

<text x='326' y='80' transform='rotate(0 326,80)' title='fk_mod_file_arquivo_autor_0 mod_file_arquivo_autor to mod_file_arquivo ( id_arquivo -> id )'>id_arquivo</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'    title='fk_mod_file_arquivo_assunto mod_file_arquivo_assunto to mod_file_arquivo ( id_arquivo -> id )' d='M 336 364 L 329,364 Q 322,364 322,357 L 322,280'  />

<text x='284' y='360' transform='rotate(0 284,360)' title='fk_mod_file_arquivo_assunto mod_file_arquivo_assunto to mod_file_arquivo ( id_arquivo -> id )'>id_arquivo</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'    title='fk_mod_file_arquivo_assunto_0 mod_file_arquivo_assunto to mod_file_assunto ( id_assunto -> id )' d='M 504 378 L 588,378'  />

<text x='513' y='374' transform='rotate(0 513,374)' title='fk_mod_file_arquivo_assunto_0 mod_file_arquivo_assunto to mod_file_assunto ( id_assunto -> id )'>id_assunto</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'    title='fk_mod_file_publicado mod_file_publicado to mod_file_arquivo ( idarquivo -> id )' d='M 448 196 L 336,196'  />

<text x='402' y='192' transform='rotate(0 402,192)' title='fk_mod_file_publicado mod_file_publicado to mod_file_arquivo ( idarquivo -> id )'>idarquivo</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'    title='fk_mod_file_arquivoorientado mod_file_arquivo_orientado to mod_file_arquivo ( idarquivo -> id )' d='M 70 350 L 70,280'  />

<text x='73' y='346' transform='rotate(270 73,346)' title='fk_mod_file_arquivoorientado mod_file_arquivo_orientado to mod_file_arquivo ( idarquivo -> id )'>idarquivo</text><path transform='translate(7,0)' marker-start='url(#foot)' marker-end='url(#arrow)'  style='stroke-dasharray:4,2;'  title='fk_mod_file_arquivo_orientado mod_file_arquivo_orientado to mod_file_orientador ( orientador -> id )' d='M 210 476 L 210,511 Q 210,518 217,518 L 224,518'  />

<text x='219' y='478' transform='rotate(90 219,478)' title='fk_mod_file_arquivo_orientado mod_file_arquivo_orientado to mod_file_orientador ( orientador -> id )'>orientador</text><!-- ============= Table 'mod_file_arquivo_autor' ============= -->
<rect class='table' x='392' y='35' width='140' height='70' rx='7' ry='7' />
<path d='M 392.50 56.00 L 392.50 42.50 Q 392.50 35.50 399.50 35.50 L 524.50 35.50 Q 531.50 35.50 531.50 42.50 L 531.50 56.00 L392.50 56.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#mod_file_arquivo_autor' title='lelic.mod_file_arquivo_autor' ><text x='400' y='49' class='tableTitle'>mod_file_arquivo_autor</text></a>
  <a xlink:href='#id_arquivo' title='Primary Key  ( id_arquivo, id_autor ) Index  ( id_arquivo ) '><use id='idx' x='394' y='68' xlink:href='#idx'/></a>
<a xlink:href='#id_arquivo' title='INT not null '><text x='406' y='77' class='fk'>id_arquivo</text><text x='501' y='77' class='colType'>INT</text></a>
<a xlink:href='#id_arquivo' title='References mod_file_arquivo ( id_arquivo -> id ) '><use id='fk' x='518' y='66' xlink:href='#fk'/></a>
  <a xlink:href='#id_autor' title='Primary Key  ( id_arquivo, id_autor ) Index  ( id_autor ) '><use id='idx' x='394' y='82' xlink:href='#idx'/></a>
<a xlink:href='#id_autor' title='INT not null '><text x='406' y='91' class='fk'>id_autor</text><text x='501' y='91' class='colType'>INT</text></a>
<a xlink:href='#id_autor' title='References mod_file_autor ( id_autor -> id ) '><use id='fk' x='518' y='80' xlink:href='#fk'/></a>

<!-- ============= Table 'mod_file_arquivo_assunto' ============= -->
<rect class='table' x='350' y='357' width='154' height='70' rx='7' ry='7' />
<path d='M 350.50 378.00 L 350.50 364.50 Q 350.50 357.50 357.50 357.50 L 496.50 357.50 Q 503.50 357.50 503.50 364.50 L 503.50 378.00 L350.50 378.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#mod_file_arquivo_assunto' title='lelic.mod_file_arquivo_assunto' ><text x='358' y='371' class='tableTitle'>mod_file_arquivo_assunto</text></a>
  <a xlink:href='#id_arquivo' title='Primary Key  ( id_arquivo, id_assunto ) Index  ( id_arquivo ) '><use id='idx' x='352' y='390' xlink:href='#idx'/></a>
<a xlink:href='#id_arquivo' title='INT not null '><text x='364' y='399' class='fk'>id_arquivo</text><text x='473' y='399' class='colType'>INT</text></a>
<a xlink:href='#id_arquivo' title='References mod_file_arquivo ( id_arquivo -> id ) '><use id='fk' x='490' y='388' xlink:href='#fk'/></a>
  <a xlink:href='#id_assunto' title='Primary Key  ( id_arquivo, id_assunto ) Index  ( id_assunto ) '><use id='idx' x='352' y='404' xlink:href='#idx'/></a>
<a xlink:href='#id_assunto' title='INT not null '><text x='364' y='413' class='fk'>id_assunto</text><text x='473' y='413' class='colType'>INT</text></a>
<a xlink:href='#id_assunto' title='References mod_file_assunto ( id_assunto -> id ) '><use id='fk' x='490' y='402' xlink:href='#fk'/></a>

<!-- ============= Table 'mod_file_arquivo' ============= -->
<rect class='table' x='42' y='147' width='294' height='126' rx='7' ry='7' />
<path d='M 42.50 168.00 L 42.50 154.50 Q 42.50 147.50 49.50 147.50 L 328.50 147.50 Q 335.50 147.50 335.50 154.50 L 335.50 168.00 L42.50 168.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#mod_file_arquivo' title='lelic.mod_file_arquivo' ><text x='143' y='161' class='tableTitle'>mod_file_arquivo</text></a>
  <a xlink:href='#id' title='Primary Key  ( id ) '><use id='pk' x='44' y='180' xlink:href='#pk'/></a>
<a xlink:href='#id' title='INT not null '><text x='56' y='189' class='pk'>id</text><text x='305' y='189' class='colType'>INT</text></a>
<a xlink:href='#id' title='Referred by mod_file_arquivo_autor ( id_arquivo -> id ) Referred by mod_file_arquivo_assunto ( id_arquivo -> id ) Referred by mod_file_arquivo_orientado ( idarquivo -> id ) Referred by mod_file_publicado ( idarquivo -> id ) '><use id='ref' x='322' y='178' xlink:href='#ref'/></a>
  <a xlink:href='#titulo' title='Index  ( titulo ) '><use id='idx' x='44' y='194' xlink:href='#idx'/></a>
<a xlink:href='#titulo' title='VARCHAR&#040; 50 &#041; not null '><text x='56' y='203' >titulo</text><text x='245' y='203' class='colType'>VARCHAR( 50 )</text></a>
  <a xlink:href='#sub_titulo' title='Index  ( sub_titulo ) '><use id='idx' x='44' y='208' xlink:href='#idx'/></a>
<a xlink:href='#sub_titulo' title='VARCHAR&#040; 50 &#041; '><text x='56' y='217' >sub_titulo</text><text x='245' y='217' class='colType'>VARCHAR( 50 )</text></a>
  <a xlink:href='#ano' title='DATE '><text x='56' y='231' >ano</text><text x='295' y='231' class='colType'>DATE</text></a>
  <a xlink:href='#tipo' title='Index  ( tipo ) '><use id='idx' x='44' y='236' xlink:href='#idx'/></a>
<a xlink:href='#tipo' title='ENUM&#040; &#039;tcc&#039;&#044;&#039;tese&#039;&#044;&#039;artigo&#039;&#044;&#039;sic&#039;&#044;&#039;dissertacoes&#039; &#041;  not null '><text x='56' y='245' >tipo</text><text x='90' y='245' class='colType'>ENUM( 'tcc','tese','artigo','sic','dissertacoes' ) </text></a>
  <a xlink:href='#criado_em' title='DATETIME not null '><text x='56' y='259' >criado_em</text><text x='270' y='259' class='colType'>DATETIME</text></a>

<!-- ============= Table 'mod_file_publicado' ============= -->
<rect class='table' x='462' y='189' width='168' height='98' rx='7' ry='7' />
<path d='M 462.50 210.00 L 462.50 196.50 Q 462.50 189.50 469.50 189.50 L 622.50 189.50 Q 629.50 189.50 629.50 196.50 L 629.50 210.00 L462.50 210.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#mod_file_publicado' title='lelic.mod_file_publicado' ><text x='494' y='203' class='tableTitle'>mod_file_publicado</text></a>
  <a xlink:href='#idarquivo' title='Primary Key  ( idarquivo ) '><use id='pk' x='464' y='222' xlink:href='#pk'/></a>
<a xlink:href='#idarquivo' title='INT not null '><text x='476' y='231' class='fk'>idarquivo</text><text x='599' y='231' class='colType'>INT</text></a>
<a xlink:href='#idarquivo' title='References mod_file_arquivo ( idarquivo -> id ) '><use id='fk' x='616' y='220' xlink:href='#fk'/></a>
  <a xlink:href='#periodico' title='Index  ( periodico ) '><use id='idx' x='464' y='236' xlink:href='#idx'/></a>
<a xlink:href='#periodico' title='VARCHAR&#040; 50 &#041; not null '><text x='476' y='245' >periodico</text><text x='539' y='245' class='colType'>VARCHAR( 50 )</text></a>
  <a xlink:href='#paginas' title='VARCHAR&#040; 10 &#041; '><text x='476' y='259' >paginas</text><text x='541' y='259' class='colType'>VARCHAR( 10 )</text></a>
  <a xlink:href='#cidade' title='VARCHAR&#040; 50 &#041; not null '><text x='476' y='273' >cidade</text><text x='539' y='273' class='colType'>VARCHAR( 50 )</text></a>

<!-- ============= Table 'mod_file_autor' ============= -->
<rect class='table' x='602' y='35' width='154' height='70' rx='7' ry='7' />
<path d='M 602.50 56.00 L 602.50 42.50 Q 602.50 35.50 609.50 35.50 L 748.50 35.50 Q 755.50 35.50 755.50 42.50 L 755.50 56.00 L602.50 56.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#mod_file_autor' title='lelic.mod_file_autor' ><text x='639' y='49' class='tableTitle'>mod_file_autor</text></a>
  <a xlink:href='#id' title='Primary Key  ( id ) '><use id='pk' x='604' y='68' xlink:href='#pk'/></a>
<a xlink:href='#id' title='INT not null '><text x='616' y='77' class='pk'>id</text><text x='725' y='77' class='colType'>INT</text></a>
<a xlink:href='#id' title='Referred by mod_file_arquivo_autor ( id_autor -> id ) '><use id='ref' x='742' y='66' xlink:href='#ref'/></a>
  <a xlink:href='#nome' title='Index  ( nome ) '><use id='idx' x='604' y='82' xlink:href='#idx'/></a>
<a xlink:href='#nome' title='VARCHAR&#040; 100 &#041; not null '><text x='616' y='91' >nome</text><text x='660' y='91' class='colType'>VARCHAR( 100 )</text></a>

<!-- ============= Table 'mod_file_assunto' ============= -->
<rect class='table' x='602' y='357' width='168' height='70' rx='7' ry='7' />
<path d='M 602.50 378.00 L 602.50 364.50 Q 602.50 357.50 609.50 357.50 L 762.50 357.50 Q 769.50 357.50 769.50 364.50 L 769.50 378.00 L602.50 378.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#mod_file_assunto' title='lelic.mod_file_assunto' ><text x='640' y='371' class='tableTitle'>mod_file_assunto</text></a>
  <a xlink:href='#id' title='Primary Key  ( id ) '><use id='pk' x='604' y='390' xlink:href='#pk'/></a>
<a xlink:href='#id' title='INT not null '><text x='616' y='399' class='pk'>id</text><text x='739' y='399' class='colType'>INT</text></a>
<a xlink:href='#id' title='Referred by mod_file_arquivo_assunto ( id_assunto -> id ) '><use id='ref' x='756' y='388' xlink:href='#ref'/></a>
  <a xlink:href='#assunto' title='Unique Index  ( assunto ) '><use id='unq' x='604' y='404' xlink:href='#unq'/></a>
<a xlink:href='#assunto' title='VARCHAR&#040; 50 &#041; not null '><text x='616' y='413' >assunto</text><text x='679' y='413' class='colType'>VARCHAR( 50 )</text></a>

<!-- ============= Table 'mod_file_arquivo_orientado' ============= -->
<rect class='table' x='56' y='357' width='196' height='112' rx='7' ry='7' />
<path d='M 56.50 378.00 L 56.50 364.50 Q 56.50 357.50 63.50 357.50 L 244.50 357.50 Q 251.50 357.50 251.50 364.50 L 251.50 378.00 L56.50 378.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#mod_file_arquivo_orientado' title='lelic.mod_file_arquivo_orientado' ><text x='80' y='371' class='tableTitle'>mod_file_arquivo_orientado</text></a>
  <a xlink:href='#idarquivo' title='Index  ( idarquivo ) '><use id='idx' x='58' y='390' xlink:href='#idx'/></a>
<a xlink:href='#idarquivo' title='INT not null '><text x='70' y='399' class='fk'>idarquivo</text><text x='221' y='399' class='colType'>INT</text></a>
<a xlink:href='#idarquivo' title='References mod_file_arquivo ( idarquivo -> id ) '><use id='fk' x='238' y='388' xlink:href='#fk'/></a>
  <a xlink:href='#curso' title='VARCHAR&#040; 50 &#041; not null '><text x='70' y='413' >curso</text><text x='161' y='413' class='colType'>VARCHAR( 50 )</text></a>
  <a xlink:href='#local' title='VARCHAR&#040; 50 &#041; not null '><text x='70' y='427' >local</text><text x='161' y='427' class='colType'>VARCHAR( 50 )</text></a>
  <a xlink:href='#universidade' title='Index  ( universidade ) '><use id='idx' x='58' y='432' xlink:href='#idx'/></a>
<a xlink:href='#universidade' title='VARCHAR&#040; 50 &#041; not null '><text x='70' y='441' >universidade</text><text x='161' y='441' class='colType'>VARCHAR( 50 )</text></a>
  <a xlink:href='#orientador' title='Index  ( orientador ) '><use id='idx' x='58' y='446' xlink:href='#idx'/></a>
<a xlink:href='#orientador' title='INT '><text x='70' y='455' class='fk'>orientador</text><text x='221' y='455' class='colType'>INT</text></a>
<a xlink:href='#orientador' title='References mod_file_orientador ( orientador -> id ) '><use id='fk' x='238' y='444' xlink:href='#fk'/></a>

<!-- ============= Table 'mod_file_orientador' ============= -->
<rect class='table' x='238' y='511' width='154' height='70' rx='7' ry='7' />
<path d='M 238.50 532.00 L 238.50 518.50 Q 238.50 511.50 245.50 511.50 L 384.50 511.50 Q 391.50 511.50 391.50 518.50 L 391.50 532.00 L238.50 532.00 ' style='fill:url(#tableHeaderGradient); stroke:none;' />
<a xlink:href='#mod_file_orientador' title='lelic.mod_file_orientador' ><text x='261' y='525' class='tableTitle'>mod_file_orientador</text></a>
  <a xlink:href='#id' title='Primary Key  ( id ) '><use id='pk' x='240' y='544' xlink:href='#pk'/></a>
<a xlink:href='#id' title='INT not null '><text x='252' y='553' class='pk'>id</text><text x='361' y='553' class='colType'>INT</text></a>
<a xlink:href='#id' title='Referred by mod_file_arquivo_orientado ( orientador -> id ) '><use id='ref' x='378' y='542' xlink:href='#ref'/></a>
  <a xlink:href='#nome' title='Index  ( nome ) '><use id='idx' x='240' y='558' xlink:href='#idx'/></a>
<a xlink:href='#nome' title='VARCHAR&#040; 50 &#041; not null '><text x='252' y='567' >nome</text><text x='301' y='567' class='colType'>VARCHAR( 50 )</text></a>

</g></svg>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='mod_file_arquivo'>mod_file_arquivo</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='id'>id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='titulo'>titulo</a></td>
		<td width='40%'> VARCHAR&#040; 50 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='sub_titulo'>sub&#095;titulo</a></td>
		<td width='40%'> VARCHAR&#040; 50 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='ano'>ano</a></td>
		<td width='40%'> DATE     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='tipo'>tipo</a></td>
		<td width='40%'> ENUM    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='criado_em'>criado&#095;em</a></td>
		<td width='40%'> DATETIME    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>idx&#095;mod&#095;file&#095;arquivo&#095;sub&#095;titulo </td>
		<td> ( sub&#095;titulo) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;mod&#095;file&#095;arquivo&#095;titulo </td>
		<td> ( titulo) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;mod&#095;file&#095;arquivo&#095;tipo </td>
		<td> ( tipo) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>pk&#095;mod&#095;file&#095;arquivo primary key</td>
		<td> ( id) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='mod_file_arquivo_assunto'>mod_file_arquivo_assunto</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='id_arquivo'>id&#095;arquivo</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='id_assunto'>id&#095;assunto</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;mod&#095;file&#095;arquivo&#095;assunto primary key</td>
		<td> ( id&#095;arquivo, id&#095;assunto) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;mod&#095;file&#095;arquivo&#095;assunto </td>
		<td> ( id&#095;arquivo) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;mod&#095;file&#095;arquivo&#095;assunto&#095;0 </td>
		<td> ( id&#095;assunto) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_mod_file_arquivo_assunto</td>
		<td > (  id&#095;arquivo  ) ref <a href='#mod&#095;file&#095;arquivo'>mod&#095;file&#095;arquivo</a> ( id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_mod_file_arquivo_assunto_0</td>
		<td > (  id&#095;assunto  ) ref <a href='#mod&#095;file&#095;assunto'>mod&#095;file&#095;assunto</a> ( id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='mod_file_arquivo_autor'>mod_file_arquivo_autor</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='id_arquivo'>id&#095;arquivo</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='id_autor'>id&#095;autor</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>idx&#095;mod&#095;file&#095;arquivo&#095;autor primary key</td>
		<td> ( id&#095;arquivo, id&#095;autor) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;mod&#095;file&#095;arquivo&#095;autor&#095;0 </td>
		<td> ( id&#095;autor) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;mod&#095;file&#095;arquivo&#095;autor&#095;1 </td>
		<td> ( id&#095;arquivo) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_mod_file_arquivo_autor</td>
		<td > (  id&#095;autor  ) ref <a href='#mod&#095;file&#095;autor'>mod&#095;file&#095;autor</a> ( id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_mod_file_arquivo_autor_0</td>
		<td > (  id&#095;arquivo  ) ref <a href='#mod&#095;file&#095;arquivo'>mod&#095;file&#095;arquivo</a> ( id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='mod_file_arquivo_orientado'>mod_file_arquivo_orientado</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='idarquivo'>idarquivo</a></td>
		<td width='40%'> INT    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='curso'>curso</a></td>
		<td width='40%'> VARCHAR&#040; 50 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='local'>local</a></td>
		<td width='40%'> VARCHAR&#040; 50 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='universidade'>universidade</a></td>
		<td width='40%'> VARCHAR&#040; 50 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='orientador'>orientador</a></td>
		<td width='40%'> INT     </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>idx&#095;mod&#095;file&#095;arquivoorientado </td>
		<td> ( idarquivo) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;mod&#095;file&#095;arquivo&#095;orientado </td>
		<td> ( orientador) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;mod&#095;file&#095;arquivo&#095;orientado&#095;0 </td>
		<td> ( universidade) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_mod_file_arquivoorientado</td>
		<td > (  idarquivo  ) ref <a href='#mod&#095;file&#095;arquivo'>mod&#095;file&#095;arquivo</a> ( id ) </td>
		<td>  </td>
	</tr>
	<tr>
		<td class='name'>fk_mod_file_arquivo_orientado</td>
		<td > (  orientador  ) ref <a href='#mod&#095;file&#095;orientador'>mod&#095;file&#095;orientador</a> ( id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='mod_file_assunto'>mod_file_assunto</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='id'>id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='assunto'>assunto</a></td>
		<td width='40%'> VARCHAR&#040; 50 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;mod&#095;file&#095;assunto primary key</td>
		<td> ( id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>pk&#095;mod&#095;file&#095;assunto&#095;0 unique</td>
		<td> ( assunto) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='mod_file_autor'>mod_file_autor</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='id'>id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='nome'>nome</a></td>
		<td width='40%'> VARCHAR&#040; 100 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;autor primary key</td>
		<td> ( id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;mod&#095;file&#095;autor&#095;nome </td>
		<td> ( nome) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='mod_file_orientador'>mod_file_orientador</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='id'>id</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='nome'>nome</a></td>
		<td width='40%'> VARCHAR&#040; 50 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;mod&#095;file&#095;orientador primary key</td>
		<td> ( id) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;mod&#095;file&#095;orientador&#095;nome </td>
		<td> ( nome) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

<br/><br/>
<table id='dbs' >
<thead>
<tr><th colspan='3'><a name='mod_file_publicado'>mod_file_publicado</a></th></tr>
</thead>
<tbody>
	<tr>
		<td class='name'><a name='idarquivo'>idarquivo</a></td>
		<td width='40%'> INT    NOT NULL  AUTOINCREMENT   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='periodico'>periodico</a></td>
		<td width='40%'> VARCHAR&#040; 50 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='paginas'>paginas</a></td>
		<td width='40%'> VARCHAR&#040; 10 &#041;     </td>
		<td width='60%'>  </td>
	</tr>
	<tr>
		<td class='name'><a name='cidade'>cidade</a></td>
		<td width='40%'> VARCHAR&#040; 50 &#041;    NOT NULL   </td>
		<td width='60%'>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Indexes</b></td></tr>
	<tr>		<td class='name'>pk&#095;mod&#095;file&#095;publicado primary key</td>
		<td> ( idarquivo) </td>
		<td>  </td>
	</tr>
	<tr>		<td class='name'>idx&#095;mod&#095;file&#095;publicado </td>
		<td> ( periodico) </td>
		<td>  </td>
	</tr>
<tr><td colspan='3' class='subpart'><b>Foreign Keys</b></td></tr>
	<tr>
		<td class='name'>fk_mod_file_publicado</td>
		<td > (  idarquivo  ) ref <a href='#mod&#095;file&#095;arquivo'>mod&#095;file&#095;arquivo</a> ( id ) </td>
		<td>  </td>
	</tr>
</tbody>
</table>

</body></html>